SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_updateRecruitmentState]

	(
	@param_id int,
	@param_state Bit
	)

AS
	/* SET NOCOUNT ON */
	Update JOL_Recruitment 
	set state=@param_state, verify_time = getdate()  -- doo 20110215
	where id=@param_id
	RETURN

GO
